package cz.czu.pef.DataModelling.utils;


public class Constants
{
	public static final String springProductionClasspathConfig = "classpath*:/app-prod-*-config.xml";
	public static final String springTestingClasspathConfig = "classpath*:/app-test-*-config.xml";

	public static final String missingTrainingsHqlSelect =
    "select emp, rr, reqTT from Employee as emp " +
    " join emp.roles as rr join rr.roleType.traningTypesForRoleTypes as ttfrt " +
    " join ttfrt.trainingType as reqTT " +
    " where reqTT.code not in (select haveTT.code from Employee as emp2 " +
    "                          join emp2.person.trainings as tt2 " +
    "                          join tt2.trainingType haveTT " +
    "                          where emp2 = emp " +
    "                            and (tt2.evidencePassExpiration is null or tt2.evidencePassExpiration > current_date())) " +
    " order by emp.person.lastName, rr.roleType.code, reqTT.code";


	public static final String missingMedicalExaminationsHqlSelect =
    "select emp, rr, reqTT from Employee as emp " +
    " join emp.roles as rr join rr.roleType.medExamTypesForRoleTypes as ttfrt " +
    " join ttfrt.medicalExaminationType as reqTT " +
    " where reqTT.code not in (select haveTT.code from Employee as emp2 " +
    "                          join emp2.person.medicalExaminations as tt2 " +
    "                          join tt2.medicalExaminationType haveTT " +
    "                          where emp2 = emp) " +
    " order by emp.person.lastName, rr.roleType.code, reqTT.code";
}
